2025-06-13 14:21:14,677 [ 179920 ] INFO : ClickHouse root is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse (runner:53, check_args_and_update_paths) 2025-06-13 14:21:14,677 [ 179920 ] INFO : Cases dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:79, check_args_and_update_paths) 2025-06-13 14:21:14,677 [ 179920 ] INFO : utils dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/utils (runner:90, check_args_and_update_paths) 2025-06-13 14:21:14,677 [ 179920 ] INFO : base_configs_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/programs/server, binary: /home/ubuntu/_work/_temp/test/build/clickhouse, cases_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:92, check_args_and_update_paths) clickhouse_integration_tests_volume Running pytest container as: 'docker run --rm --name clickhouse_integration_tests_jwodtn --privileged --dns-search='.' --memory=30709035008 --security-opt seccomp=unconfined --cap-add=SYS_PTRACE --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=5dc43a6382f0 -e DOCKER_BASE_TAG=5ccda723c1fc -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=d862517635bf -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=1 --color=no --durations=0 --report-log=parallel0_1.jsonl --report-log-exclude-logs-on-passed-tests test_asynchronous_metric_jemalloc_profile_active/test.py::test_asynchronous_metric_jemalloc_profile_active test_backup_restore_on_cluster/test_different_versions.py::test_different_versions 'test_cow_policy/test.py::test_cow_policy[cow_policy_multi_disk]' 'test_cow_policy/test.py::test_cow_policy[cow_policy_multi_volume]' -vvv " altinityinfra/integration-tests-runner:ad96270260ff '. Start tests ============================= test session starts ============================== platform linux -- Python 3.10.12, pytest-7.4.4, pluggy-1.5.0 -- /usr/bin/python3 cachedir: .pytest_cache Test order randomisation NOT enabled. Enable with --random-order or --random-order-bucket= rootdir: /ClickHouse/tests/integration configfile: pytest.ini plugins: timeout-2.3.1, repeat-0.9.3, order-1.0.0, reportlog-0.4.0, xdist-3.5.0, random-order-1.1.1 timeout: 900.0s timeout method: signal timeout func_only: False created: 10/10 workers 10 workers [4 items] scheduling tests via LoadFileScheduling test_backup_restore_on_cluster/test_different_versions.py::test_different_versions test_cow_policy/test.py::test_cow_policy[cow_policy_multi_disk] test_asynchronous_metric_jemalloc_profile_active/test.py::test_asynchronous_metric_jemalloc_profile_active [gw3] [ 25%] SKIPPED test_asynchronous_metric_jemalloc_profile_active/test.py::test_asynchronous_metric_jemalloc_profile_active [gw1] [ 50%] FAILED test_backup_restore_on_cluster/test_different_versions.py::test_different_versions [gw0] [ 75%] FAILED test_cow_policy/test.py::test_cow_policy[cow_policy_multi_disk] test_cow_policy/test.py::test_cow_policy[cow_policy_multi_volume] [gw0] [100%] FAILED test_cow_policy/test.py::test_cow_policy[cow_policy_multi_volume] =================================== FAILURES =================================== ___________________________ test_different_versions ____________________________ [gw1] linux -- Python 3.10.12 /usr/bin/python3 def test_different_versions(): new_node.query( "CREATE TABLE tbl" " ON CLUSTER 'cluster_ver'" " (x UInt64) ENGINE=ReplicatedMergeTree('/clickhouse/tables/tbl/', '{replica}')" " ORDER BY tuple()" ) new_node.query(f"INSERT INTO tbl VALUES (1)") old_node.query(f"INSERT INTO tbl VALUES (2)") backup_name = new_backup_name() initiator = random_node() print(f"Using {get_node_name(initiator)} as initiator for BACKUP") initiator.query(f"BACKUP TABLE tbl ON CLUSTER 'cluster_ver' TO {backup_name}") new_node.query("DROP TABLE tbl ON CLUSTER 'cluster_ver' SYNC") initiator = random_node() print(f"Using {get_node_name(initiator)} as initiator for RESTORE") initiator.query(f"RESTORE TABLE tbl ON CLUSTER 'cluster_ver' FROM {backup_name}") new_node.query("SYSTEM SYNC REPLICA ON CLUSTER 'cluster_ver' tbl") assert new_node.query("SELECT * FROM tbl ORDER BY x") == TSV([1, 2]) assert old_node.query("SELECT * FROM tbl ORDER BY x") == TSV([1, 2]) # Error NO_ELEMENTS_IN_CONFIG is unrelated. > assert ( new_node.query( "SELECT name, last_error_message FROM system.errors WHERE NOT (" "(name == 'NO_ELEMENTS_IN_CONFIG')" ")" ) == "" ) E assert "NETLINK_ERROR\tCan\\'t receive Netlink response: error -2\n" == '' E + NETLINK_ERROR Can\'t receive Netlink response: error -2 test_backup_restore_on_cluster/test_different_versions.py:105: AssertionError ---------------------------- Captured stdout setup ----------------------------- Copy common default production configuration from /clickhouse-config. Files: config.xml, users.xml Copy common default production configuration from /clickhouse-config. Files: config.xml, users.xml ------------------------------ Captured log setup ------------------------------ 2025-06-13 14:21:21 [ 643 ] DEBUG : Command:[docker ps | wc -l] (cluster.py:121, run_and_check) 2025-06-13 14:21:21 [ 643 ] DEBUG : Stdout:1 (cluster.py:145, run_and_check) 2025-06-13 14:21:21 [ 643 ] DEBUG : No running containers (conftest.py:95, cleanup_environment) 2025-06-13 14:21:21 [ 643 ] DEBUG : Pruning Docker networks (conftest.py:97, cleanup_environment) 2025-06-13 14:21:21 [ 643 ] DEBUG : Command:[docker network prune --force] (cluster.py:121, run_and_check) 2025-06-13 14:21:21 [ 643 ] DEBUG : Command:[sysctl net.ipv4.ip_local_port_range='55000 65535'] (cluster.py:121, run_and_check) 2025-06-13 14:21:21 [ 643 ] DEBUG : Stdout:net.ipv4.ip_local_port_range = 55000 65535 (cluster.py:145, run_and_check) 2025-06-13 14:21:21 [ 643 ] INFO : Running tests in /ClickHouse/tests/integration/test_backup_restore_on_cluster/test_different_versions.py (cluster.py:2672, start) 2025-06-13 14:21:21 [ 643 ] DEBUG : Cluster start called. is_up=False (cluster.py:2679, start) 2025-06-13 14:21:21 [ 643 ] DEBUG : Docker networks for project roottestbackuprestoreonclusterdifferentversions-gw1 are NETWORK ID NAME DRIVER SCOPE (cluster.py:825, print_all_docker_pieces) 2025-06-13 14:21:21 [ 643 ] DEBUG : Docker containers for project roottestbackuprestoreonclusterdifferentversions-gw1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:833, print_all_docker_pieces) 2025-06-13 14:21:21 [ 643 ] DEBUG : Docker volumes for project roottestbackuprestoreonclusterdifferentversions-gw1 are DRIVER VOLUME NAME (cluster.py:841, print_all_docker_pieces) 2025-06-13 14:21:21 [ 643 ] DEBUG : Cleanup called (cluster.py:846, cleanup) 2025-06-13 14:21:21 [ 643 ] DEBUG : Docker networks for project roottestbackuprestoreonclusterdifferentversions-gw1 are NETWORK ID NAME DRIVER SCOPE (cluster.py:825, print_all_docker_pieces) 2025-06-13 14:21:21 [ 643 ] DEBUG : Docker containers for project roottestbackuprestoreonclusterdifferentversions-gw1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:833, print_all_docker_pieces) 2025-06-13 14:21:21 [ 643 ] DEBUG : Docker volumes for project roottestbackuprestoreonclusterdifferentversions-gw1 are DRIVER VOLUME NAME (cluster.py:841, print_all_docker_pieces) 2025-06-13 14:21:21 [ 643 ] DEBUG : Command:[docker container list --all --filter name='^/roottestbackuprestoreonclusterdifferentversions-gw1-.*-1$' --format '{{.ID}}:{{.Names}}'] (cluster.py:121, run_and_check) 2025-06-13 14:21:21 [ 643 ] DEBUG : Unstopped containers: {} (cluster.py:860, cleanup) 2025-06-13 14:21:21 [ 643 ] DEBUG : No running containers for project: roottestbackuprestoreonclusterdifferentversions-gw1 (cluster.py:874, cleanup) 2025-06-13 14:21:21 [ 643 ] DEBUG : Trying to prune unused networks... (cluster.py:880, cleanup) 2025-06-13 14:21:21 [ 643 ] DEBUG : Trying to prune unused images... (cluster.py:896, cleanup) 2025-06-13 14:21:21 [ 643 ] DEBUG : Command:[docker image prune -f] (cluster.py:121, run_and_check) 2025-06-13 14:21:21 [ 643 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:145, run_and_check) 2025-06-13 14:21:21 [ 643 ] DEBUG : Images pruned (cluster.py:899, cleanup) 2025-06-13 14:21:21 [ 643 ] DEBUG : Trying to prune unused volumes... (cluster.py:905, cleanup) 2025-06-13 14:21:21 [ 643 ] DEBUG : Command:[docker volume ls | wc -l] (cluster.py:121, run_and_check) 2025-06-13 14:21:21 [ 643 ] DEBUG : Stdout:1 (cluster.py:145, run_and_check) 2025-06-13 14:21:21 [ 643 ] DEBUG : Volumes pruned: 1 (cluster.py:910, cleanup) 2025-06-13 14:21:21 [ 643 ] DEBUG : Setup directory for instance: new_node (cluster.py:2692, start) 2025-06-13 14:21:21 [ 643 ] DEBUG : Create directory for configuration generated in this helper (cluster.py:4536, create_dir) 2025-06-13 14:21:21 [ 643 ] DEBUG : Create directory for common tests configuration (cluster.py:4541, create_dir) 2025-06-13 14:21:21 [ 643 ] DEBUG : Copy common configuration from helpers (cluster.py:4561, create_dir) 2025-06-13 14:21:21 [ 643 ] DEBUG : Generate and write macros file (cluster.py:4613, create_dir) 2025-06-13 14:21:21 [ 643 ] DEBUG : Copy custom test config files ['/ClickHouse/tests/integration/test_backup_restore_on_cluster/configs/backups_disk.xml', '/ClickHouse/tests/integration/test_backup_restore_on_cluster/configs/cluster_different_versions.xml'] to /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/new_node/configs/config.d (cluster.py:4649, create_dir) 2025-06-13 14:21:21 [ 643 ] DEBUG : Setup database dir /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/new_node/database (cluster.py:4666, create_dir) 2025-06-13 14:21:21 [ 643 ] DEBUG : Setup logs dir /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/new_node/logs (cluster.py:4677, create_dir) 2025-06-13 14:21:21 [ 643 ] DEBUG : Entrypoint cmd: ["clickhouse", "server", "--config-file=/etc/clickhouse-server/config.xml", "--log-file=/var/log/clickhouse-server/clickhouse-server.log", "--errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log", "--"] (cluster.py:4758, create_dir) 2025-06-13 14:21:21 [ 643 ] INFO : external_dir_abs_path=/ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/backups (cluster.py:4787, create_dir) 2025-06-13 14:21:21 [ 643 ] DEBUG : Setup directory for instance: old_node (cluster.py:2692, start) 2025-06-13 14:21:21 [ 643 ] DEBUG : Create directory for configuration generated in this helper (cluster.py:4536, create_dir) 2025-06-13 14:21:21 [ 643 ] DEBUG : Create directory for common tests configuration (cluster.py:4541, create_dir) 2025-06-13 14:21:21 [ 643 ] DEBUG : Copy common configuration from helpers (cluster.py:4561, create_dir) 2025-06-13 14:21:21 [ 643 ] DEBUG : Generate and write macros file (cluster.py:4613, create_dir) 2025-06-13 14:21:21 [ 643 ] DEBUG : Copy custom test config files ['/ClickHouse/tests/integration/test_backup_restore_on_cluster/configs/backups_disk.xml', '/ClickHouse/tests/integration/test_backup_restore_on_cluster/configs/cluster_different_versions.xml'] to /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/old_node/configs/config.d (cluster.py:4649, create_dir) 2025-06-13 14:21:21 [ 643 ] DEBUG : Setup database dir /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/old_node/database (cluster.py:4666, create_dir) 2025-06-13 14:21:21 [ 643 ] DEBUG : Setup logs dir /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/old_node/logs (cluster.py:4677, create_dir) 2025-06-13 14:21:21 [ 643 ] DEBUG : Entrypoint cmd: ["clickhouse", "server", "--config-file=/etc/clickhouse-server/config.xml", "--log-file=/var/log/clickhouse-server/clickhouse-server.log", "--errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log", "--"] (cluster.py:4758, create_dir) 2025-06-13 14:21:21 [ 643 ] INFO : external_dir_abs_path=/ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/backups (cluster.py:4787, create_dir) 2025-06-13 14:21:21 [ 643 ] DEBUG : Env {'ASAN_OPTIONS': 'use_sigaltstack=0', 'TSAN_OPTIONS': 'use_sigaltstack=0', 'CLICKHOUSE_WATCHDOG_ENABLE': '0', 'CLICKHOUSE_NATS_TLS_SECURE': '0', 'LLVM_PROFILE_FILE': '/var/lib/clickhouse/server_%h_%p_%m.profraw', 'keeper_binary': '/clickhouse', 'keeper_cmd_prefix': 'clickhouse keeper', 'image': 'altinityinfra/integration-test:5ccda723c1fc', 'user': '0', 'keeper_fs': 'bind', 'keeper_logs_dir1': '/ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/keeper1/log', 'keeper_config_dir1': '/ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/keeper1/config', 'keeper_db_dir1': '/ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/keeper1/coordination', 'keeper_logs_dir2': '/ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/keeper2/log', 'keeper_config_dir2': '/ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/keeper2/config', 'keeper_db_dir2': '/ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/keeper2/coordination', 'keeper_logs_dir3': '/ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/keeper3/log', 'keeper_config_dir3': '/ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/keeper3/config', 'keeper_db_dir3': '/ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/keeper3/coordination'} stored in /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/.env (cluster.py:96, _create_env_file) 2025-06-13 14:21:21 [ 643 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2025-06-13 14:21:21 [ 643 ] DEBUG : No config file found (config.py:28, find_config_file) 2025-06-13 14:21:21 [ 643 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2025-06-13 14:21:21 [ 643 ] DEBUG : No config file found (config.py:28, find_config_file) 2025-06-13 14:21:21 [ 643 ] DEBUG : http://localhost:None "GET /version HTTP/1.1" 200 826 (connectionpool.py:547, _make_request) 2025-06-13 14:21:21 [ 643 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/.env --project-name roottestbackuprestoreonclusterdifferentversions-gw1 --file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/new_node/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml --file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/old_node/docker-compose.yml pull] (cluster.py:121, run_and_check) 2025-06-13 14:21:32 [ 643 ] DEBUG : Stderr: new_node Skipped - Image is already being pulled by zoo1 (cluster.py:147, run_and_check) 2025-06-13 14:21:32 [ 643 ] DEBUG : Stderr: zoo2 Skipped - Image is already being pulled by zoo1 (cluster.py:147, run_and_check) 2025-06-13 14:21:32 [ 643 ] DEBUG : Stderr: zoo3 Skipped - Image is already being pulled by zoo1 (cluster.py:147, run_and_check) 2025-06-13 14:21:32 [ 643 ] DEBUG : Stderr: zoo1 Pulling (cluster.py:147, run_and_check) 2025-06-13 14:21:32 [ 643 ] DEBUG : Stderr: old_node Pulling (cluster.py:147, run_and_check) 2025-06-13 14:21:32 [ 643 ] DEBUG : Stderr: zoo1 Pulled (cluster.py:147, run_and_check) 2025-06-13 14:21:32 [ 643 ] DEBUG : Stderr: old_node Pulled (cluster.py:147, run_and_check) 2025-06-13 14:21:32 [ 643 ] DEBUG : Setup ZooKeeper (cluster.py:2733, start) 2025-06-13 14:21:32 [ 643 ] DEBUG : Creating internal ZooKeeper dirs: ['/ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/keeper1/log', '/ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/keeper1/config', '/ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/keeper1/coordination', '/ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/keeper2/log', '/ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/keeper2/config', '/ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/keeper2/coordination', '/ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/keeper3/log', '/ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/keeper3/config', '/ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/keeper3/coordination'] (cluster.py:2734, start) 2025-06-13 14:21:32 [ 643 ] DEBUG : Command:[docker compose --project-name roottestbackuprestoreonclusterdifferentversions-gw1 --env-file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/.env --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml --verbose up -d] (cluster.py:121, run_and_check) 2025-06-13 14:21:33 [ 643 ] DEBUG : Stderr:time="2025-06-13T14:21:32Z" level=trace msg="Docker Desktop integration not enabled" (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 643 ] DEBUG : Stderr: Network roottestbackuprestoreonclusterdifferentversions-gw1_default Creating (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 643 ] DEBUG : Stderr: Network roottestbackuprestoreonclusterdifferentversions-gw1_default Created (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo2-1 Creating (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo1-1 Creating (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo3-1 Creating (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo3-1 Created (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo2-1 Created (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo1-1 Created (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo2-1 Starting (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo3-1 Starting (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo1-1 Starting (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo1-1 Started (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo3-1 Started (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo2-1 Started (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 643 ] DEBUG : Stderr:time="2025-06-13T14:21:33Z" level=debug msg="otel error" error="" (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 643 ] DEBUG : Stderr:time="2025-06-13T14:21:33Z" level=debug msg="otel error" error="" (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 643 ] DEBUG : Wait ZooKeeper to start (cluster.py:2398, wait_zookeeper_to_start) 2025-06-13 14:21:33 [ 643 ] DEBUG : get_instance_ip instance_name=zoo1 (cluster.py:1999, get_instance_ip) 2025-06-13 14:21:33 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestbackuprestoreonclusterdifferentversions-gw1-zoo1-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:33 [ 643 ] DEBUG : get_kazoo_client: zoo1, ip:172.16.3.4, port:2181, use_ssl:False (cluster.py:3234, get_kazoo_client) 2025-06-13 14:21:33 [ 643 ] INFO : Connecting to 172.16.3.4(172.16.3.4):2181, use_ssl: False (connection.py:650, _connect) 2025-06-13 14:21:33 [ 643 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2025-06-13 14:21:33 [ 643 ] INFO : Connecting to 172.16.3.4(172.16.3.4):2181, use_ssl: False (connection.py:650, _connect) 2025-06-13 14:21:33 [ 643 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2025-06-13 14:21:33 [ 643 ] INFO : Connecting to 172.16.3.4(172.16.3.4):2181, use_ssl: False (connection.py:650, _connect) 2025-06-13 14:21:33 [ 643 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2025-06-13 14:21:34 [ 643 ] INFO : Connecting to 172.16.3.4(172.16.3.4):2181, use_ssl: False (connection.py:650, _connect) 2025-06-13 14:21:34 [ 643 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2025-06-13 14:21:35 [ 643 ] INFO : Connecting to 172.16.3.4(172.16.3.4):2181, use_ssl: False (connection.py:650, _connect) 2025-06-13 14:21:35 [ 643 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2025-06-13 14:21:36 [ 643 ] INFO : Connecting to 172.16.3.4(172.16.3.4):2181, use_ssl: False (connection.py:650, _connect) 2025-06-13 14:21:36 [ 643 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2025-06-13 14:21:39 [ 643 ] INFO : Connecting to 172.16.3.4(172.16.3.4):2181, use_ssl: False (connection.py:650, _connect) 2025-06-13 14:21:39 [ 643 ] DEBUG : Sending request(xid=None): Connect(protocol_version=0, last_zxid_seen=0, time_out=30000, session_id=0, passwd=b'\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00', read_only=None) (connection.py:312, _submit) 2025-06-13 14:21:39 [ 643 ] INFO : Zookeeper connection established, state: CONNECTED (client.py:532, _session_callback) 2025-06-13 14:21:39 [ 643 ] DEBUG : Sending request(xid=1): GetChildren(path='/', watcher=None) (connection.py:312, _submit) 2025-06-13 14:21:39 [ 643 ] DEBUG : Received response(xid=1): ['keeper'] (connection.py:410, _read_response) 2025-06-13 14:21:39 [ 643 ] DEBUG : Sending request(xid=2): Close() (connection.py:312, _submit) 2025-06-13 14:21:39 [ 643 ] WARNING : Connection dropped: socket connection broken (connection.py:622, _connect_attempt) 2025-06-13 14:21:39 [ 643 ] WARNING : Transition to CONNECTING (connection.py:626, _connect_attempt) 2025-06-13 14:21:39 [ 643 ] INFO : Zookeeper connection lost (client.py:543, _session_callback) 2025-06-13 14:21:39 [ 643 ] WARNING : Failed connecting to Zookeeper within the connection retry policy. (connection.py:515, zk_loop) 2025-06-13 14:21:39 [ 643 ] INFO : Zookeeper session closed, state: CLOSED (client.py:537, _session_callback) 2025-06-13 14:21:39 [ 643 ] DEBUG : get_instance_ip instance_name=zoo2 (cluster.py:1999, get_instance_ip) 2025-06-13 14:21:39 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestbackuprestoreonclusterdifferentversions-gw1-zoo2-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:39 [ 643 ] DEBUG : get_kazoo_client: zoo2, ip:172.16.3.3, port:2181, use_ssl:False (cluster.py:3234, get_kazoo_client) 2025-06-13 14:21:39 [ 643 ] INFO : Connecting to 172.16.3.3(172.16.3.3):2181, use_ssl: False (connection.py:650, _connect) 2025-06-13 14:21:39 [ 643 ] DEBUG : Sending request(xid=None): Connect(protocol_version=0, last_zxid_seen=0, time_out=30000, session_id=0, passwd=b'\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00', read_only=None) (connection.py:312, _submit) 2025-06-13 14:21:39 [ 643 ] INFO : Zookeeper connection established, state: CONNECTED (client.py:532, _session_callback) 2025-06-13 14:21:39 [ 643 ] DEBUG : Sending request(xid=1): GetChildren(path='/', watcher=None) (connection.py:312, _submit) 2025-06-13 14:21:39 [ 643 ] DEBUG : Received response(xid=1): ['keeper'] (connection.py:410, _read_response) 2025-06-13 14:21:39 [ 643 ] DEBUG : Sending request(xid=2): Close() (connection.py:312, _submit) 2025-06-13 14:21:39 [ 643 ] WARNING : Connection dropped: socket connection broken (connection.py:622, _connect_attempt) 2025-06-13 14:21:39 [ 643 ] WARNING : Transition to CONNECTING (connection.py:626, _connect_attempt) 2025-06-13 14:21:39 [ 643 ] INFO : Zookeeper connection lost (client.py:543, _session_callback) 2025-06-13 14:21:39 [ 643 ] WARNING : Failed connecting to Zookeeper within the connection retry policy. (connection.py:515, zk_loop) 2025-06-13 14:21:39 [ 643 ] INFO : Zookeeper session closed, state: CLOSED (client.py:537, _session_callback) 2025-06-13 14:21:39 [ 643 ] DEBUG : get_instance_ip instance_name=zoo3 (cluster.py:1999, get_instance_ip) 2025-06-13 14:21:39 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestbackuprestoreonclusterdifferentversions-gw1-zoo3-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:39 [ 643 ] DEBUG : get_kazoo_client: zoo3, ip:172.16.3.2, port:2181, use_ssl:False (cluster.py:3234, get_kazoo_client) 2025-06-13 14:21:39 [ 643 ] INFO : Connecting to 172.16.3.2(172.16.3.2):2181, use_ssl: False (connection.py:650, _connect) 2025-06-13 14:21:39 [ 643 ] DEBUG : Sending request(xid=None): Connect(protocol_version=0, last_zxid_seen=0, time_out=30000, session_id=0, passwd=b'\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00', read_only=None) (connection.py:312, _submit) 2025-06-13 14:21:39 [ 643 ] INFO : Zookeeper connection established, state: CONNECTED (client.py:532, _session_callback) 2025-06-13 14:21:39 [ 643 ] DEBUG : Sending request(xid=1): GetChildren(path='/', watcher=None) (connection.py:312, _submit) 2025-06-13 14:21:39 [ 643 ] DEBUG : Received response(xid=1): ['keeper'] (connection.py:410, _read_response) 2025-06-13 14:21:39 [ 643 ] DEBUG : Sending request(xid=2): Close() (connection.py:312, _submit) 2025-06-13 14:21:39 [ 643 ] WARNING : Connection dropped: socket connection broken (connection.py:622, _connect_attempt) 2025-06-13 14:21:39 [ 643 ] WARNING : Transition to CONNECTING (connection.py:626, _connect_attempt) 2025-06-13 14:21:39 [ 643 ] INFO : Zookeeper connection lost (client.py:543, _session_callback) 2025-06-13 14:21:39 [ 643 ] WARNING : Failed connecting to Zookeeper within the connection retry policy. (connection.py:515, zk_loop) 2025-06-13 14:21:39 [ 643 ] INFO : Zookeeper session closed, state: CLOSED (client.py:537, _session_callback) 2025-06-13 14:21:39 [ 643 ] DEBUG : All instances of ZooKeeper started: ('zoo1', 'zoo2', 'zoo3') (cluster.py:2414, wait_zookeeper_nodes_to_start) 2025-06-13 14:21:39 [ 643 ] DEBUG : ('Trying to create ClickHouse instance by command %s', 'docker compose --env-file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/.env --project-name roottestbackuprestoreonclusterdifferentversions-gw1 --file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/new_node/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml --file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/old_node/docker-compose.yml up -d --no-recreate') (cluster.py:3061, start) 2025-06-13 14:21:39 [ 643 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/.env --project-name roottestbackuprestoreonclusterdifferentversions-gw1 --file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/new_node/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml --file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/old_node/docker-compose.yml up -d --no-recreate] (cluster.py:121, run_and_check) 2025-06-13 14:21:40 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo1-1 Running (cluster.py:147, run_and_check) 2025-06-13 14:21:40 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo2-1 Running (cluster.py:147, run_and_check) 2025-06-13 14:21:40 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo3-1 Running (cluster.py:147, run_and_check) 2025-06-13 14:21:40 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-new_node-1 Creating (cluster.py:147, run_and_check) 2025-06-13 14:21:40 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-old_node-1 Creating (cluster.py:147, run_and_check) 2025-06-13 14:21:40 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-old_node-1 Created (cluster.py:147, run_and_check) 2025-06-13 14:21:40 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-new_node-1 Created (cluster.py:147, run_and_check) 2025-06-13 14:21:40 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-new_node-1 Starting (cluster.py:147, run_and_check) 2025-06-13 14:21:40 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-old_node-1 Starting (cluster.py:147, run_and_check) 2025-06-13 14:21:40 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-new_node-1 Started (cluster.py:147, run_and_check) 2025-06-13 14:21:40 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-old_node-1 Started (cluster.py:147, run_and_check) 2025-06-13 14:21:40 [ 643 ] DEBUG : ClickHouse instance created (cluster.py:3069, start) 2025-06-13 14:21:40 [ 643 ] DEBUG : get_instance_ip instance_name=new_node (cluster.py:1999, get_instance_ip) 2025-06-13 14:21:40 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestbackuprestoreonclusterdifferentversions-gw1-new_node-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:40 [ 643 ] DEBUG : get_instance_ip instance_name=new_node (cluster.py:2009, get_instance_global_ipv6) 2025-06-13 14:21:40 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestbackuprestoreonclusterdifferentversions-gw1-new_node-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:40 [ 643 ] DEBUG : Waiting for ClickHouse start in new_node, ip: 172.16.3.6... (cluster.py:3077, start) 2025-06-13 14:21:40 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestbackuprestoreonclusterdifferentversions-gw1-new_node-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:40 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:40 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:40 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:40 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:40 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:40 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:40 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:40 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:41 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:41 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:41 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:41 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:41 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:41 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:41 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:41 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:41 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:41 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:42 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:42 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:42 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:42 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:42 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:42 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:42 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:42 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:42 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:43 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/d00afc9275c2b1bf80d92f3d1539de05511f27fdd859393a5373d9f4479f3bfb/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:43 [ 643 ] DEBUG : ClickHouse new_node started (cluster.py:3081, start) 2025-06-13 14:21:43 [ 643 ] DEBUG : get_instance_ip instance_name=old_node (cluster.py:1999, get_instance_ip) 2025-06-13 14:21:43 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestbackuprestoreonclusterdifferentversions-gw1-old_node-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:43 [ 643 ] DEBUG : get_instance_ip instance_name=old_node (cluster.py:2009, get_instance_global_ipv6) 2025-06-13 14:21:43 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestbackuprestoreonclusterdifferentversions-gw1-old_node-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:43 [ 643 ] DEBUG : Waiting for ClickHouse start in old_node, ip: 172.16.3.5... (cluster.py:3077, start) 2025-06-13 14:21:43 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestbackuprestoreonclusterdifferentversions-gw1-old_node-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:43 [ 643 ] DEBUG : http://localhost:None "GET /v1.46/containers/5737d2bdb4690e6cc61a3a1e27ef141ed91d696910d18e32929016f8ec4bbf2a/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:43 [ 643 ] DEBUG : ClickHouse old_node started (cluster.py:3081, start) ----------------------------- Captured stdout call ----------------------------- Using new_node as initiator for BACKUP Using new_node as initiator for RESTORE ------------------------------ Captured log call ------------------------------- 2025-06-13 14:21:43 [ 643 ] DEBUG : Executing query CREATE TABLE tbl ON CLUSTER 'cluster_ver' (x UInt64) ENGINE=ReplicatedMergeTree('/clickhouse/tables/tbl/', '{replica}') ORDER BY tuple() on new_node (cluster.py:3570, query) 2025-06-13 14:21:43 [ 643 ] DEBUG : Executing query INSERT INTO tbl VALUES (1) on new_node (cluster.py:3570, query) 2025-06-13 14:21:43 [ 643 ] DEBUG : Executing query INSERT INTO tbl VALUES (2) on old_node (cluster.py:3570, query) 2025-06-13 14:21:44 [ 643 ] DEBUG : Executing query BACKUP TABLE tbl ON CLUSTER 'cluster_ver' TO Disk('backups', '1') on new_node (cluster.py:3570, query) 2025-06-13 14:21:45 [ 643 ] DEBUG : Executing query DROP TABLE tbl ON CLUSTER 'cluster_ver' SYNC on new_node (cluster.py:3570, query) 2025-06-13 14:21:45 [ 643 ] DEBUG : Executing query RESTORE TABLE tbl ON CLUSTER 'cluster_ver' FROM Disk('backups', '1') on new_node (cluster.py:3570, query) 2025-06-13 14:21:46 [ 643 ] DEBUG : Executing query SYSTEM SYNC REPLICA ON CLUSTER 'cluster_ver' tbl on new_node (cluster.py:3570, query) 2025-06-13 14:21:46 [ 643 ] DEBUG : Executing query SELECT * FROM tbl ORDER BY x on new_node (cluster.py:3570, query) 2025-06-13 14:21:47 [ 643 ] DEBUG : Executing query SELECT * FROM tbl ORDER BY x on old_node (cluster.py:3570, query) 2025-06-13 14:21:47 [ 643 ] DEBUG : Executing query SELECT name, last_error_message FROM system.errors WHERE NOT ((name == 'NO_ELEMENTS_IN_CONFIG')) on new_node (cluster.py:3570, query) ---------------------------- Captured log teardown ----------------------------- 2025-06-13 14:21:47 [ 643 ] DEBUG : Executing query DROP TABLE IF EXISTS tbl ON CLUSTER 'cluster_ver' SYNC on new_node (cluster.py:3570, query) 2025-06-13 14:21:48 [ 643 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/.env --project-name roottestbackuprestoreonclusterdifferentversions-gw1 --file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/new_node/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml --file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/old_node/docker-compose.yml stop --timeout 20] (cluster.py:121, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-new_node-1 Stopping (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-old_node-1 Stopping (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-old_node-1 Stopped (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-new_node-1 Stopped (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo3-1 Stopping (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo2-1 Stopping (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo1-1 Stopping (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo1-1 Stopped (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo3-1 Stopped (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo2-1 Stopped (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Command:[bash -c [ -f /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/new_node/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/new_node/logs/stderr.log* | ( [ -z "" ] && cat || grep -v "$" ) || true] (cluster.py:121, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Command:[bash -c [ -f /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/old_node/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/old_node/logs/stderr.log* | ( [ -z "" ] && cat || grep -v "$" ) || true] (cluster.py:121, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/.env --project-name roottestbackuprestoreonclusterdifferentversions-gw1 --file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/new_node/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml --file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-different_versions-1-gw1/old_node/docker-compose.yml down --volumes] (cluster.py:121, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-new_node-1 Stopping (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-old_node-1 Stopping (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-new_node-1 Stopped (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-new_node-1 Removing (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-old_node-1 Stopped (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-old_node-1 Removing (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-new_node-1 Removed (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-old_node-1 Removed (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo3-1 Stopping (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo1-1 Stopping (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo2-1 Stopping (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo3-1 Stopped (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo3-1 Removing (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo1-1 Stopped (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo1-1 Removing (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo2-1 Stopped (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo2-1 Removing (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo1-1 Removed (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo3-1 Removed (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Container roottestbackuprestoreonclusterdifferentversions-gw1-zoo2-1 Removed (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Network roottestbackuprestoreonclusterdifferentversions-gw1_default Removing (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Stderr: Network roottestbackuprestoreonclusterdifferentversions-gw1_default Removed (cluster.py:147, run_and_check) 2025-06-13 14:21:55 [ 643 ] DEBUG : Cleanup called (cluster.py:846, cleanup) 2025-06-13 14:21:55 [ 643 ] DEBUG : Docker networks for project roottestbackuprestoreonclusterdifferentversions-gw1 are NETWORK ID NAME DRIVER SCOPE (cluster.py:825, print_all_docker_pieces) 2025-06-13 14:21:56 [ 643 ] DEBUG : Docker containers for project roottestbackuprestoreonclusterdifferentversions-gw1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:833, print_all_docker_pieces) 2025-06-13 14:21:56 [ 643 ] DEBUG : Docker volumes for project roottestbackuprestoreonclusterdifferentversions-gw1 are DRIVER VOLUME NAME (cluster.py:841, print_all_docker_pieces) 2025-06-13 14:21:56 [ 643 ] DEBUG : Command:[docker container list --all --filter name='^/roottestbackuprestoreonclusterdifferentversions-gw1-.*-1$' --format '{{.ID}}:{{.Names}}'] (cluster.py:121, run_and_check) 2025-06-13 14:21:56 [ 643 ] DEBUG : Unstopped containers: {} (cluster.py:860, cleanup) 2025-06-13 14:21:56 [ 643 ] DEBUG : No running containers for project: roottestbackuprestoreonclusterdifferentversions-gw1 (cluster.py:874, cleanup) 2025-06-13 14:21:56 [ 643 ] DEBUG : Trying to prune unused networks... (cluster.py:880, cleanup) 2025-06-13 14:21:56 [ 643 ] DEBUG : Trying to prune unused images... (cluster.py:896, cleanup) 2025-06-13 14:21:56 [ 643 ] DEBUG : Command:[docker image prune -f] (cluster.py:121, run_and_check) 2025-06-13 14:21:56 [ 643 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:145, run_and_check) 2025-06-13 14:21:56 [ 643 ] DEBUG : Images pruned (cluster.py:899, cleanup) 2025-06-13 14:21:56 [ 643 ] DEBUG : Trying to prune unused volumes... (cluster.py:905, cleanup) 2025-06-13 14:21:56 [ 643 ] DEBUG : Command:[docker volume ls | wc -l] (cluster.py:121, run_and_check) 2025-06-13 14:21:56 [ 643 ] DEBUG : Stdout:1 (cluster.py:145, run_and_check) 2025-06-13 14:21:56 [ 643 ] DEBUG : Volumes pruned: 1 (cluster.py:910, cleanup) ____________________ test_cow_policy[cow_policy_multi_disk] ____________________ [gw0] linux -- Python 3.10.12 /usr/bin/python3 start_cluster = storage_policy = 'cow_policy_multi_disk' @pytest.mark.parametrize("storage_policy", ["cow_policy_multi_disk", "cow_policy_multi_volume"]) def test_cow_policy(start_cluster, storage_policy): try: > node.query_with_retry( f""" ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS storage_policy = '{storage_policy}' """, timeout=60, retry_count=3, ) test_cow_policy/test.py:24: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = sql = "\n ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7'\n (\n ...R BY (postcode1, postcode2, addr1, addr2)\n SETTINGS storage_policy = 'cow_policy_multi_disk'\n " stdin = None, timeout = 60, settings = None, user = None, password = None database = None, host = None, ignore_error = False, retry_count = 3 sleep_time = 0.5 check_callback = at 0x7fe5e0f47ac0> parse = False def query_with_retry( self, sql, stdin=None, timeout=None, settings=None, user=None, password=None, database=None, host=None, ignore_error=False, retry_count=20, sleep_time=0.5, check_callback=lambda x: True, parse=False, ): # logging.debug(f"Executing query {sql} on {self.name}") result = None exception_msg = "" for i in range(retry_count): try: result = self.query( sql, stdin=stdin, timeout=timeout, settings=settings, user=user, password=password, database=database, host=host, ignore_error=ignore_error, parse=parse, ) if check_callback(result): return result time.sleep(sleep_time) except QueryRuntimeException as ex: exception_msg = f"{type(ex).__name__}: {str(ex)}" # Container is down, this is likely due to server crash. if "No route to host" in str(ex): raise time.sleep(sleep_time) except Exception as ex: # logging.debug("Retry {} got exception {}".format(i + 1, ex)) exception_msg = f"{type(ex).__name__}: {str(ex)}" time.sleep(sleep_time) if result is not None: return result > raise Exception(f"Can't execute query {sql}\n{exception_msg}") E Exception: Can't execute query E ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' E ( E price UInt32, E date Date, E postcode1 LowCardinality(String), E postcode2 LowCardinality(String), E type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), E is_new UInt8, E duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), E addr1 String, E addr2 String, E street LowCardinality(String), E locality LowCardinality(String), E town LowCardinality(String), E district LowCardinality(String), E county LowCardinality(String) E ) E ENGINE = MergeTree E ORDER BY (postcode1, postcode2, addr1, addr2) E SETTINGS storage_policy = 'cow_policy_multi_disk' E E QueryRuntimeException: Client failed! Return code: 198, stderr: Received exception from server (version 25.3.3): E Code: 198. DB::Exception: Received from 172.16.1.2:9000. DB::NetException. DB::NetException: Not found address of host: raw.githubusercontent.com: while loading disk metadata. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/__exception/exception.h:106: Poco::Exception::Exception(String const&, int) @ 0x0000000020d7a680 E 1. ./build_docker/./src/Common/Exception.cpp:108: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x0000000010abea94 E 2. ./src/Common/Exception.h:112: DB::NetException::NetException(int, FormatStringHelperImpl::type>, String const&) @ 0x0000000010a7b139 E 3. ./build_docker/./src/Common/DNSResolver.cpp:113: DB::(anonymous namespace)::hostByName(String const&) @ 0x0000000010a76aa3 E 4. ./build_docker/./src/Common/DNSResolver.cpp:138: DB::DNSResolver::getResolvedIPAdressessWithFiltering(String const&) @ 0x0000000010a75073 E 5. ./build_docker/./src/Common/DNSResolver.cpp:256: DB::DNSResolver::resolveIPAddressWithCache(String const&) @ 0x0000000010a75659 E 6. ./build_docker/./src/Common/DNSResolver.cpp:276: DB::DNSResolver::resolveHostAllInOriginOrder(String const&) @ 0x0000000010a75d90 E 7. ./build_docker/./src/Common/HostResolvePool.cpp:54: std::vector> std::__function::__policy_invoker> (String const&)>::__call_impl[abi:ne190107]> (String const&)>>(std::__function::__policy_storage const*, String const&) @ 0x0000000010f48349 E 8. ./contrib/llvm-project/libcxx/include/__functional/function.h:716: ? @ 0x0000000010f461b4 E 9. ./build_docker/./src/Common/HostResolvePool.cpp:66: DB::HostResolver::HostResolver(std::function> (String const&)>&&, String, Poco::Timespan) @ 0x0000000010f45fdf E 10. ./build_docker/./src/Common/HostResolvePool.cpp:53: DB::HostResolver::HostResolver(String, Poco::Timespan) @ 0x0000000010f45c7e E 11. ./src/Common/HostResolvePool.h:62: std::shared_ptr DB::HostResolver::create(String const&)::make_shared_enabler::make_shared_enabler(String const&) @ 0x0000000010f4b243 E 12. ./contrib/llvm-project/libcxx/include/__memory/construct_at.h:41: std::shared_ptr DB::HostResolver::create(String const&)::make_shared_enabler> std::allocate_shared[abi:ne190107] DB::HostResolver::create(String const&)::make_shared_enabler, std::allocator DB::HostResolver::create(String const&)::make_shared_enabler>, String const&, 0>(std::allocator DB::HostResolver::create(String const&)::make_shared_enabler> const&, String const&) @ 0x0000000010f4af46 E 13. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:851: DB::HostResolversPool::getResolver(String const&) @ 0x0000000010f48211 E 14. ./build_docker/./src/Common/HTTPConnectionPool.cpp:671: DB::EndpointConnectionPool::prepareNewConnection(DB::ConnectionTimeouts const&, unsigned long*) @ 0x0000000010f3a836 E 15. ./build_docker/./src/Common/HTTPConnectionPool.cpp:590: DB::EndpointConnectionPool::getConnection(DB::ConnectionTimeouts const&, unsigned long*) @ 0x0000000010f39a98 E 16. ./build_docker/./src/IO/HTTPCommon.cpp:63: DB::makeHTTPSession(DB::HTTPConnectionGroupType, Poco::URI const&, DB::ConnectionTimeouts const&, DB::ProxyConfiguration const&, unsigned long*) @ 0x0000000010f5244d E 17. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:267: DB::ReadWriteBufferFromHTTP::callImpl(Poco::Net::HTTPResponse&, String const&, std::optional const&, bool) const @ 0x0000000013c58685 E 18. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:285: DB::ReadWriteBufferFromHTTP::callWithRedirects(Poco::Net::HTTPResponse&, String const&, std::optional const&) @ 0x0000000013c58934 E 19. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:408: DB::ReadWriteBufferFromHTTP::initialize() @ 0x0000000013c593e0 E 20. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:472: void std::__function::__policy_invoker::__call_impl[abi:ne190107]>(std::__function::__policy_storage const*) @ 0x0000000013c5c597 E 21. ./contrib/llvm-project/libcxx/include/__functional/function.h:716: ? @ 0x0000000013c55df9 E 22. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:465: DB::ReadWriteBufferFromHTTP::nextImpl() @ 0x0000000013c5aaa1 E 23. DB::ReadBuffer::next() @ 0x00000000088d9c7b E 24. ./src/IO/ReadBuffer.h:96: DB::WebObjectStorage::loadFiles(String const&, std::unique_lock const&) const @ 0x00000000178fd379 E 25. ./build_docker/./src/Disks/ObjectStorages/Web/WebObjectStorage.cpp:225: DB::WebObjectStorage::tryGetFileInfo(String const&) const @ 0x00000000179007fa E 26. ./build_docker/./src/Disks/ObjectStorages/Web/WebObjectStorage.cpp:185: DB::WebObjectStorage::tryGetFileInfo(String const&) const @ 0x000000001790021a E 27. ./build_docker/./src/Disks/ObjectStorages/Web/MetadataStorageFromStaticFilesWebServer.cpp:106: DB::MetadataStorageFromStaticFilesWebServer::getStorageObjectsIfExist(String const&) const @ 0x00000000178fa7c5 E 28. ./build_docker/./src/Disks/ObjectStorages/DiskObjectStorage.cpp:785: DB::DiskObjectStorage::readFileIfExists(String const&, DB::ReadSettings const&, std::optional, std::optional) const @ 0x0000000017860fb2 E 29. ./build_docker/./src/Storages/MergeTree/MergeTreeData.cpp:382: DB::MergeTreeData::initializeDirectoriesAndFormatVersion(String const&, bool, String const&, bool) @ 0x000000001b28277d E 30. ./build_docker/./src/Storages/StorageMergeTree.cpp:159: DB::StorageMergeTree::StorageMergeTree(DB::StorageID const&, String const&, DB::StorageInMemoryMetadata const&, DB::LoadingStrictnessLevel, std::shared_ptr, String const&, DB::MergeTreeData::MergingParams const&, std::unique_ptr>) @ 0x000000001b754547 E 31. ./contrib/llvm-project/libcxx/include/__memory/construct_at.h:41: std::shared_ptr std::allocate_shared[abi:ne190107], DB::StorageID const&, String const&, DB::StorageInMemoryMetadata&, DB::LoadingStrictnessLevel const&, std::shared_ptr&, String&, DB::MergeTreeData::MergingParams&, std::unique_ptr>, 0>(std::allocator const&, DB::StorageID const&, String const&, DB::StorageInMemoryMetadata&, DB::LoadingStrictnessLevel const&, std::shared_ptr&, String&, DB::MergeTreeData::MergingParams&, std::unique_ptr>&&) @ 0x000000001b753e64 E . (DNS_ERROR) E (query: ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' E ( E price UInt32, E date Date, E postcode1 LowCardinality(String), E postcode2 LowCardinality(String), E type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), E is_new UInt8, E duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), E addr1 String, E addr2 String, E street LowCardinality(String), E locality LowCardinality(String), E town LowCardinality(String), E district LowCardinality(String), E county LowCardinality(String) E ) E ENGINE = MergeTree E ORDER BY (postcode1, postcode2, addr1, addr2) E SETTINGS storage_policy = 'cow_policy_multi_disk' E ) helpers/cluster.py:3634: Exception ---------------------------- Captured stdout setup ----------------------------- Copy common default production configuration from /clickhouse-config. Files: config.xml, users.xml ------------------------------ Captured log setup ------------------------------ 2025-06-13 14:21:21 [ 640 ] DEBUG : Command:[docker ps | wc -l] (cluster.py:121, run_and_check) 2025-06-13 14:21:21 [ 640 ] DEBUG : Stdout:1 (cluster.py:145, run_and_check) 2025-06-13 14:21:21 [ 640 ] DEBUG : No running containers (conftest.py:95, cleanup_environment) 2025-06-13 14:21:21 [ 640 ] DEBUG : Pruning Docker networks (conftest.py:97, cleanup_environment) 2025-06-13 14:21:21 [ 640 ] DEBUG : Command:[docker network prune --force] (cluster.py:121, run_and_check) 2025-06-13 14:21:21 [ 640 ] DEBUG : Command:[sysctl net.ipv4.ip_local_port_range='55000 65535'] (cluster.py:121, run_and_check) 2025-06-13 14:21:21 [ 640 ] DEBUG : Stdout:net.ipv4.ip_local_port_range = 55000 65535 (cluster.py:145, run_and_check) 2025-06-13 14:21:21 [ 640 ] INFO : Running tests in /ClickHouse/tests/integration/test_cow_policy/test.py (cluster.py:2672, start) 2025-06-13 14:21:21 [ 640 ] DEBUG : Cluster start called. is_up=False (cluster.py:2679, start) 2025-06-13 14:21:21 [ 640 ] DEBUG : Docker networks for project roottestcowpolicy-gw0 are NETWORK ID NAME DRIVER SCOPE (cluster.py:825, print_all_docker_pieces) 2025-06-13 14:21:21 [ 640 ] DEBUG : Docker containers for project roottestcowpolicy-gw0 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:833, print_all_docker_pieces) 2025-06-13 14:21:21 [ 640 ] DEBUG : Docker volumes for project roottestcowpolicy-gw0 are DRIVER VOLUME NAME (cluster.py:841, print_all_docker_pieces) 2025-06-13 14:21:21 [ 640 ] DEBUG : Cleanup called (cluster.py:846, cleanup) 2025-06-13 14:21:21 [ 640 ] DEBUG : Docker networks for project roottestcowpolicy-gw0 are NETWORK ID NAME DRIVER SCOPE (cluster.py:825, print_all_docker_pieces) 2025-06-13 14:21:21 [ 640 ] DEBUG : Docker containers for project roottestcowpolicy-gw0 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:833, print_all_docker_pieces) 2025-06-13 14:21:21 [ 640 ] DEBUG : Docker volumes for project roottestcowpolicy-gw0 are DRIVER VOLUME NAME (cluster.py:841, print_all_docker_pieces) 2025-06-13 14:21:21 [ 640 ] DEBUG : Command:[docker container list --all --filter name='^/roottestcowpolicy-gw0-.*-1$' --format '{{.ID}}:{{.Names}}'] (cluster.py:121, run_and_check) 2025-06-13 14:21:21 [ 640 ] DEBUG : Unstopped containers: {} (cluster.py:860, cleanup) 2025-06-13 14:21:21 [ 640 ] DEBUG : No running containers for project: roottestcowpolicy-gw0 (cluster.py:874, cleanup) 2025-06-13 14:21:21 [ 640 ] DEBUG : Trying to prune unused networks... (cluster.py:880, cleanup) 2025-06-13 14:21:21 [ 640 ] DEBUG : Trying to prune unused images... (cluster.py:896, cleanup) 2025-06-13 14:21:21 [ 640 ] DEBUG : Command:[docker image prune -f] (cluster.py:121, run_and_check) 2025-06-13 14:21:21 [ 640 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:145, run_and_check) 2025-06-13 14:21:21 [ 640 ] DEBUG : Images pruned (cluster.py:899, cleanup) 2025-06-13 14:21:21 [ 640 ] DEBUG : Trying to prune unused volumes... (cluster.py:905, cleanup) 2025-06-13 14:21:21 [ 640 ] DEBUG : Command:[docker volume ls | wc -l] (cluster.py:121, run_and_check) 2025-06-13 14:21:21 [ 640 ] DEBUG : Stdout:1 (cluster.py:145, run_and_check) 2025-06-13 14:21:21 [ 640 ] DEBUG : Volumes pruned: 1 (cluster.py:910, cleanup) 2025-06-13 14:21:21 [ 640 ] DEBUG : Setup directory for instance: node (cluster.py:2692, start) 2025-06-13 14:21:21 [ 640 ] DEBUG : Create directory for configuration generated in this helper (cluster.py:4536, create_dir) 2025-06-13 14:21:21 [ 640 ] DEBUG : Create directory for common tests configuration (cluster.py:4541, create_dir) 2025-06-13 14:21:21 [ 640 ] DEBUG : Copy common configuration from helpers (cluster.py:4561, create_dir) 2025-06-13 14:21:21 [ 640 ] DEBUG : Generate and write macros file (cluster.py:4613, create_dir) 2025-06-13 14:21:21 [ 640 ] DEBUG : Copy custom test config files ['/ClickHouse/tests/integration/test_cow_policy/configs/overrides.yaml'] to /ClickHouse/tests/integration/test_cow_policy/_instances-1-gw0/node/configs/config.d (cluster.py:4649, create_dir) 2025-06-13 14:21:21 [ 640 ] DEBUG : Setup database dir /ClickHouse/tests/integration/test_cow_policy/_instances-1-gw0/node/database (cluster.py:4666, create_dir) 2025-06-13 14:21:21 [ 640 ] DEBUG : Setup logs dir /ClickHouse/tests/integration/test_cow_policy/_instances-1-gw0/node/logs (cluster.py:4677, create_dir) 2025-06-13 14:21:21 [ 640 ] DEBUG : Entrypoint cmd: ["clickhouse", "server", "--config-file=/etc/clickhouse-server/config.xml", "--log-file=/var/log/clickhouse-server/clickhouse-server.log", "--errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log", "--"] (cluster.py:4758, create_dir) 2025-06-13 14:21:21 [ 640 ] DEBUG : Env {'ASAN_OPTIONS': 'use_sigaltstack=0', 'TSAN_OPTIONS': 'use_sigaltstack=0', 'CLICKHOUSE_WATCHDOG_ENABLE': '0', 'CLICKHOUSE_NATS_TLS_SECURE': '0', 'LLVM_PROFILE_FILE': '/var/lib/clickhouse/server_%h_%p_%m.profraw'} stored in /ClickHouse/tests/integration/test_cow_policy/_instances-1-gw0/.env (cluster.py:96, _create_env_file) 2025-06-13 14:21:21 [ 640 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2025-06-13 14:21:21 [ 640 ] DEBUG : No config file found (config.py:28, find_config_file) 2025-06-13 14:21:21 [ 640 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2025-06-13 14:21:21 [ 640 ] DEBUG : No config file found (config.py:28, find_config_file) 2025-06-13 14:21:21 [ 640 ] DEBUG : http://localhost:None "GET /version HTTP/1.1" 200 826 (connectionpool.py:547, _make_request) 2025-06-13 14:21:21 [ 640 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_cow_policy/_instances-1-gw0/.env --project-name roottestcowpolicy-gw0 --file /ClickHouse/tests/integration/test_cow_policy/_instances-1-gw0/node/docker-compose.yml pull] (cluster.py:121, run_and_check) 2025-06-13 14:21:32 [ 640 ] DEBUG : Stderr: node Pulling (cluster.py:147, run_and_check) 2025-06-13 14:21:32 [ 640 ] DEBUG : Stderr: node Pulled (cluster.py:147, run_and_check) 2025-06-13 14:21:32 [ 640 ] DEBUG : ('Trying to create ClickHouse instance by command %s', 'docker compose --env-file /ClickHouse/tests/integration/test_cow_policy/_instances-1-gw0/.env --project-name roottestcowpolicy-gw0 --file /ClickHouse/tests/integration/test_cow_policy/_instances-1-gw0/node/docker-compose.yml up -d --no-recreate') (cluster.py:3061, start) 2025-06-13 14:21:32 [ 640 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_cow_policy/_instances-1-gw0/.env --project-name roottestcowpolicy-gw0 --file /ClickHouse/tests/integration/test_cow_policy/_instances-1-gw0/node/docker-compose.yml up -d --no-recreate] (cluster.py:121, run_and_check) 2025-06-13 14:21:33 [ 640 ] DEBUG : Stderr: Network roottestcowpolicy-gw0_default Creating (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 640 ] DEBUG : Stderr: Network roottestcowpolicy-gw0_default Created (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 640 ] DEBUG : Stderr: Container roottestcowpolicy-gw0-node-1 Creating (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 640 ] DEBUG : Stderr: Container roottestcowpolicy-gw0-node-1 Created (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 640 ] DEBUG : Stderr: Container roottestcowpolicy-gw0-node-1 Starting (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 640 ] DEBUG : Stderr: Container roottestcowpolicy-gw0-node-1 Started (cluster.py:147, run_and_check) 2025-06-13 14:21:33 [ 640 ] DEBUG : ClickHouse instance created (cluster.py:3069, start) 2025-06-13 14:21:33 [ 640 ] DEBUG : get_instance_ip instance_name=node (cluster.py:1999, get_instance_ip) 2025-06-13 14:21:33 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestcowpolicy-gw0-node-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:33 [ 640 ] DEBUG : get_instance_ip instance_name=node (cluster.py:2009, get_instance_global_ipv6) 2025-06-13 14:21:33 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestcowpolicy-gw0-node-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:33 [ 640 ] DEBUG : Waiting for ClickHouse start in node, ip: 172.16.1.2... (cluster.py:3077, start) 2025-06-13 14:21:33 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestcowpolicy-gw0-node-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:33 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:33 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:33 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:33 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:33 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:33 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:33 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:33 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:33 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:33 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:34 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:34 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:34 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:34 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:34 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:34 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:34 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:34 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:34 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:35 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:35 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:35 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:35 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:35 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:35 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:35 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:35 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:35 [ 640 ] DEBUG : http://localhost:None "GET /v1.46/containers/5bacf0233673829a704404bd9e9f3b5c85a4b3ee241018a7e529a324c520a5b9/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-06-13 14:21:35 [ 640 ] DEBUG : ClickHouse node started (cluster.py:3081, start) ------------------------------ Captured log call ------------------------------- 2025-06-13 14:21:35 [ 640 ] DEBUG : Executing query ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS storage_policy = 'cow_policy_multi_disk' on node (cluster.py:3570, query) 2025-06-13 14:22:29 [ 640 ] DEBUG : Executing query ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS storage_policy = 'cow_policy_multi_disk' on node (cluster.py:3570, query) 2025-06-13 14:23:24 [ 640 ] DEBUG : Executing query ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS storage_policy = 'cow_policy_multi_disk' on node (cluster.py:3570, query) 2025-06-13 14:24:19 [ 640 ] DEBUG : Executing query DROP TABLE IF EXISTS uk_price_paid SYNC on node (cluster.py:3570, query) ___________________ test_cow_policy[cow_policy_multi_volume] ___________________ [gw0] linux -- Python 3.10.12 /usr/bin/python3 start_cluster = storage_policy = 'cow_policy_multi_volume' @pytest.mark.parametrize("storage_policy", ["cow_policy_multi_disk", "cow_policy_multi_volume"]) def test_cow_policy(start_cluster, storage_policy): try: > node.query_with_retry( f""" ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS storage_policy = '{storage_policy}' """, timeout=60, retry_count=3, ) test_cow_policy/test.py:24: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = sql = "\n ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7'\n (\n ...BY (postcode1, postcode2, addr1, addr2)\n SETTINGS storage_policy = 'cow_policy_multi_volume'\n " stdin = None, timeout = 60, settings = None, user = None, password = None database = None, host = None, ignore_error = False, retry_count = 3 sleep_time = 0.5 check_callback = at 0x7fe5e0f47ac0> parse = False def query_with_retry( self, sql, stdin=None, timeout=None, settings=None, user=None, password=None, database=None, host=None, ignore_error=False, retry_count=20, sleep_time=0.5, check_callback=lambda x: True, parse=False, ): # logging.debug(f"Executing query {sql} on {self.name}") result = None exception_msg = "" for i in range(retry_count): try: result = self.query( sql, stdin=stdin, timeout=timeout, settings=settings, user=user, password=password, database=database, host=host, ignore_error=ignore_error, parse=parse, ) if check_callback(result): return result time.sleep(sleep_time) except QueryRuntimeException as ex: exception_msg = f"{type(ex).__name__}: {str(ex)}" # Container is down, this is likely due to server crash. if "No route to host" in str(ex): raise time.sleep(sleep_time) except Exception as ex: # logging.debug("Retry {} got exception {}".format(i + 1, ex)) exception_msg = f"{type(ex).__name__}: {str(ex)}" time.sleep(sleep_time) if result is not None: return result > raise Exception(f"Can't execute query {sql}\n{exception_msg}") E Exception: Can't execute query E ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' E ( E price UInt32, E date Date, E postcode1 LowCardinality(String), E postcode2 LowCardinality(String), E type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), E is_new UInt8, E duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), E addr1 String, E addr2 String, E street LowCardinality(String), E locality LowCardinality(String), E town LowCardinality(String), E district LowCardinality(String), E county LowCardinality(String) E ) E ENGINE = MergeTree E ORDER BY (postcode1, postcode2, addr1, addr2) E SETTINGS storage_policy = 'cow_policy_multi_volume' E E QueryRuntimeException: Client failed! Return code: 198, stderr: Received exception from server (version 25.3.3): E Code: 198. DB::Exception: Received from 172.16.1.2:9000. DB::NetException. DB::NetException: Not found address of host: raw.githubusercontent.com: while loading disk metadata. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/__exception/exception.h:106: Poco::Exception::Exception(String const&, int) @ 0x0000000020d7a680 E 1. ./build_docker/./src/Common/Exception.cpp:108: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x0000000010abea94 E 2. ./src/Common/Exception.h:112: DB::NetException::NetException(int, FormatStringHelperImpl::type>, String const&) @ 0x0000000010a7b139 E 3. ./build_docker/./src/Common/DNSResolver.cpp:113: DB::(anonymous namespace)::hostByName(String const&) @ 0x0000000010a76aa3 E 4. ./build_docker/./src/Common/DNSResolver.cpp:138: DB::DNSResolver::getResolvedIPAdressessWithFiltering(String const&) @ 0x0000000010a75073 E 5. ./build_docker/./src/Common/DNSResolver.cpp:256: DB::DNSResolver::resolveIPAddressWithCache(String const&) @ 0x0000000010a75659 E 6. ./build_docker/./src/Common/DNSResolver.cpp:276: DB::DNSResolver::resolveHostAllInOriginOrder(String const&) @ 0x0000000010a75d90 E 7. ./build_docker/./src/Common/HostResolvePool.cpp:54: std::vector> std::__function::__policy_invoker> (String const&)>::__call_impl[abi:ne190107]> (String const&)>>(std::__function::__policy_storage const*, String const&) @ 0x0000000010f48349 E 8. ./contrib/llvm-project/libcxx/include/__functional/function.h:716: ? @ 0x0000000010f461b4 E 9. ./build_docker/./src/Common/HostResolvePool.cpp:66: DB::HostResolver::HostResolver(std::function> (String const&)>&&, String, Poco::Timespan) @ 0x0000000010f45fdf E 10. ./build_docker/./src/Common/HostResolvePool.cpp:53: DB::HostResolver::HostResolver(String, Poco::Timespan) @ 0x0000000010f45c7e E 11. ./src/Common/HostResolvePool.h:62: std::shared_ptr DB::HostResolver::create(String const&)::make_shared_enabler::make_shared_enabler(String const&) @ 0x0000000010f4b243 E 12. ./contrib/llvm-project/libcxx/include/__memory/construct_at.h:41: std::shared_ptr DB::HostResolver::create(String const&)::make_shared_enabler> std::allocate_shared[abi:ne190107] DB::HostResolver::create(String const&)::make_shared_enabler, std::allocator DB::HostResolver::create(String const&)::make_shared_enabler>, String const&, 0>(std::allocator DB::HostResolver::create(String const&)::make_shared_enabler> const&, String const&) @ 0x0000000010f4af46 E 13. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:851: DB::HostResolversPool::getResolver(String const&) @ 0x0000000010f48211 E 14. ./build_docker/./src/Common/HTTPConnectionPool.cpp:671: DB::EndpointConnectionPool::prepareNewConnection(DB::ConnectionTimeouts const&, unsigned long*) @ 0x0000000010f3a836 E 15. ./build_docker/./src/Common/HTTPConnectionPool.cpp:590: DB::EndpointConnectionPool::getConnection(DB::ConnectionTimeouts const&, unsigned long*) @ 0x0000000010f39a98 E 16. ./build_docker/./src/IO/HTTPCommon.cpp:63: DB::makeHTTPSession(DB::HTTPConnectionGroupType, Poco::URI const&, DB::ConnectionTimeouts const&, DB::ProxyConfiguration const&, unsigned long*) @ 0x0000000010f5244d E 17. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:267: DB::ReadWriteBufferFromHTTP::callImpl(Poco::Net::HTTPResponse&, String const&, std::optional const&, bool) const @ 0x0000000013c58685 E 18. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:285: DB::ReadWriteBufferFromHTTP::callWithRedirects(Poco::Net::HTTPResponse&, String const&, std::optional const&) @ 0x0000000013c58934 E 19. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:408: DB::ReadWriteBufferFromHTTP::initialize() @ 0x0000000013c593e0 E 20. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:472: void std::__function::__policy_invoker::__call_impl[abi:ne190107]>(std::__function::__policy_storage const*) @ 0x0000000013c5c597 E 21. ./contrib/llvm-project/libcxx/include/__functional/function.h:716: ? @ 0x0000000013c55df9 E 22. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:465: DB::ReadWriteBufferFromHTTP::nextImpl() @ 0x0000000013c5aaa1 E 23. DB::ReadBuffer::next() @ 0x00000000088d9c7b E 24. ./src/IO/ReadBuffer.h:96: DB::WebObjectStorage::loadFiles(String const&, std::unique_lock const&) const @ 0x00000000178fd379 E 25. ./build_docker/./src/Disks/ObjectStorages/Web/WebObjectStorage.cpp:225: DB::WebObjectStorage::tryGetFileInfo(String const&) const @ 0x00000000179007fa E 26. ./build_docker/./src/Disks/ObjectStorages/Web/WebObjectStorage.cpp:185: DB::WebObjectStorage::tryGetFileInfo(String const&) const @ 0x000000001790021a E 27. ./build_docker/./src/Disks/ObjectStorages/Web/MetadataStorageFromStaticFilesWebServer.cpp:106: DB::MetadataStorageFromStaticFilesWebServer::getStorageObjectsIfExist(String const&) const @ 0x00000000178fa7c5 E 28. ./build_docker/./src/Disks/ObjectStorages/DiskObjectStorage.cpp:785: DB::DiskObjectStorage::readFileIfExists(String const&, DB::ReadSettings const&, std::optional, std::optional) const @ 0x0000000017860fb2 E 29. ./build_docker/./src/Storages/MergeTree/MergeTreeData.cpp:382: DB::MergeTreeData::initializeDirectoriesAndFormatVersion(String const&, bool, String const&, bool) @ 0x000000001b28277d E 30. ./build_docker/./src/Storages/StorageMergeTree.cpp:159: DB::StorageMergeTree::StorageMergeTree(DB::StorageID const&, String const&, DB::StorageInMemoryMetadata const&, DB::LoadingStrictnessLevel, std::shared_ptr, String const&, DB::MergeTreeData::MergingParams const&, std::unique_ptr>) @ 0x000000001b754547 E 31. ./contrib/llvm-project/libcxx/include/__memory/construct_at.h:41: std::shared_ptr std::allocate_shared[abi:ne190107], DB::StorageID const&, String const&, DB::StorageInMemoryMetadata&, DB::LoadingStrictnessLevel const&, std::shared_ptr&, String&, DB::MergeTreeData::MergingParams&, std::unique_ptr>, 0>(std::allocator const&, DB::StorageID const&, String const&, DB::StorageInMemoryMetadata&, DB::LoadingStrictnessLevel const&, std::shared_ptr&, String&, DB::MergeTreeData::MergingParams&, std::unique_ptr>&&) @ 0x000000001b753e64 E . (DNS_ERROR) E (query: ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' E ( E price UInt32, E date Date, E postcode1 LowCardinality(String), E postcode2 LowCardinality(String), E type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), E is_new UInt8, E duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), E addr1 String, E addr2 String, E street LowCardinality(String), E locality LowCardinality(String), E town LowCardinality(String), E district LowCardinality(String), E county LowCardinality(String) E ) E ENGINE = MergeTree E ORDER BY (postcode1, postcode2, addr1, addr2) E SETTINGS storage_policy = 'cow_policy_multi_volume' E ) helpers/cluster.py:3634: Exception ------------------------------ Captured log call ------------------------------- 2025-06-13 14:24:20 [ 640 ] DEBUG : Executing query ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS storage_policy = 'cow_policy_multi_volume' on node (cluster.py:3570, query) 2025-06-13 14:25:17 [ 640 ] DEBUG : Executing query ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS storage_policy = 'cow_policy_multi_volume' on node (cluster.py:3570, query) 2025-06-13 14:26:15 [ 640 ] DEBUG : Executing query ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS storage_policy = 'cow_policy_multi_volume' on node (cluster.py:3570, query) 2025-06-13 14:27:09 [ 640 ] DEBUG : Executing query DROP TABLE IF EXISTS uk_price_paid SYNC on node (cluster.py:3570, query) ---------------------------- Captured log teardown ----------------------------- 2025-06-13 14:27:10 [ 640 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_cow_policy/_instances-1-gw0/.env --project-name roottestcowpolicy-gw0 --file /ClickHouse/tests/integration/test_cow_policy/_instances-1-gw0/node/docker-compose.yml stop --timeout 20] (cluster.py:121, run_and_check) 2025-06-13 14:27:16 [ 640 ] DEBUG : Stderr: Container roottestcowpolicy-gw0-node-1 Stopping (cluster.py:147, run_and_check) 2025-06-13 14:27:16 [ 640 ] DEBUG : Stderr: Container roottestcowpolicy-gw0-node-1 Stopped (cluster.py:147, run_and_check) 2025-06-13 14:27:16 [ 640 ] DEBUG : Command:[bash -c [ -f /ClickHouse/tests/integration/test_cow_policy/_instances-1-gw0/node/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_cow_policy/_instances-1-gw0/node/logs/stderr.log* | ( [ -z "" ] && cat || grep -v "$" ) || true] (cluster.py:121, run_and_check) 2025-06-13 14:27:16 [ 640 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_cow_policy/_instances-1-gw0/.env --project-name roottestcowpolicy-gw0 --file /ClickHouse/tests/integration/test_cow_policy/_instances-1-gw0/node/docker-compose.yml down --volumes] (cluster.py:121, run_and_check) 2025-06-13 14:27:16 [ 640 ] DEBUG : Stderr: Container roottestcowpolicy-gw0-node-1 Stopping (cluster.py:147, run_and_check) 2025-06-13 14:27:16 [ 640 ] DEBUG : Stderr: Container roottestcowpolicy-gw0-node-1 Stopped (cluster.py:147, run_and_check) 2025-06-13 14:27:16 [ 640 ] DEBUG : Stderr: Container roottestcowpolicy-gw0-node-1 Removing (cluster.py:147, run_and_check) 2025-06-13 14:27:16 [ 640 ] DEBUG : Stderr: Container roottestcowpolicy-gw0-node-1 Removed (cluster.py:147, run_and_check) 2025-06-13 14:27:16 [ 640 ] DEBUG : Stderr: Network roottestcowpolicy-gw0_default Removing (cluster.py:147, run_and_check) 2025-06-13 14:27:16 [ 640 ] DEBUG : Stderr: Network roottestcowpolicy-gw0_default Removed (cluster.py:147, run_and_check) 2025-06-13 14:27:16 [ 640 ] DEBUG : Cleanup called (cluster.py:846, cleanup) 2025-06-13 14:27:16 [ 640 ] DEBUG : Docker networks for project roottestcowpolicy-gw0 are NETWORK ID NAME DRIVER SCOPE (cluster.py:825, print_all_docker_pieces) 2025-06-13 14:27:16 [ 640 ] DEBUG : Docker containers for project roottestcowpolicy-gw0 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:833, print_all_docker_pieces) 2025-06-13 14:27:16 [ 640 ] DEBUG : Docker volumes for project roottestcowpolicy-gw0 are DRIVER VOLUME NAME (cluster.py:841, print_all_docker_pieces) 2025-06-13 14:27:16 [ 640 ] DEBUG : Command:[docker container list --all --filter name='^/roottestcowpolicy-gw0-.*-1$' --format '{{.ID}}:{{.Names}}'] (cluster.py:121, run_and_check) 2025-06-13 14:27:16 [ 640 ] DEBUG : Unstopped containers: {} (cluster.py:860, cleanup) 2025-06-13 14:27:16 [ 640 ] DEBUG : No running containers for project: roottestcowpolicy-gw0 (cluster.py:874, cleanup) 2025-06-13 14:27:16 [ 640 ] DEBUG : Trying to prune unused networks... (cluster.py:880, cleanup) 2025-06-13 14:27:16 [ 640 ] DEBUG : Trying to prune unused images... (cluster.py:896, cleanup) 2025-06-13 14:27:16 [ 640 ] DEBUG : Command:[docker image prune -f] (cluster.py:121, run_and_check) 2025-06-13 14:27:16 [ 640 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:145, run_and_check) 2025-06-13 14:27:16 [ 640 ] DEBUG : Images pruned (cluster.py:899, cleanup) 2025-06-13 14:27:16 [ 640 ] DEBUG : Trying to prune unused volumes... (cluster.py:905, cleanup) 2025-06-13 14:27:16 [ 640 ] DEBUG : Command:[docker volume ls | wc -l] (cluster.py:121, run_and_check) 2025-06-13 14:27:16 [ 640 ] DEBUG : Stdout:1 (cluster.py:145, run_and_check) 2025-06-13 14:27:16 [ 640 ] DEBUG : Volumes pruned: 1 (cluster.py:910, cleanup) ----------------- generated report log file: parallel0_1.jsonl ----------------- ============================== slowest durations =============================== 169.88s call test_cow_policy/test.py::test_cow_policy[cow_policy_multi_volume] 164.10s call test_cow_policy/test.py::test_cow_policy[cow_policy_multi_disk] 21.46s setup test_backup_restore_on_cluster/test_different_versions.py::test_different_versions 14.30s setup test_asynchronous_metric_jemalloc_profile_active/test.py::test_asynchronous_metric_jemalloc_profile_active 14.26s setup test_cow_policy/test.py::test_cow_policy[cow_policy_multi_disk] 8.21s teardown test_backup_restore_on_cluster/test_different_versions.py::test_different_versions 6.79s teardown test_cow_policy/test.py::test_cow_policy[cow_policy_multi_volume] 4.82s call test_backup_restore_on_cluster/test_different_versions.py::test_different_versions 4.17s teardown test_asynchronous_metric_jemalloc_profile_active/test.py::test_asynchronous_metric_jemalloc_profile_active 0.37s call test_asynchronous_metric_jemalloc_profile_active/test.py::test_asynchronous_metric_jemalloc_profile_active 0.00s teardown test_cow_policy/test.py::test_cow_policy[cow_policy_multi_disk] 0.00s setup test_cow_policy/test.py::test_cow_policy[cow_policy_multi_volume] =========================== short test summary info ============================ FAILED test_backup_restore_on_cluster/test_different_versions.py::test_different_versions FAILED test_cow_policy/test.py::test_cow_policy[cow_policy_multi_disk] - Exce... FAILED test_cow_policy/test.py::test_cow_policy[cow_policy_multi_volume] - Ex... SKIPPED [1] test_asynchronous_metric_jemalloc_profile_active/test.py:30: Disabled for sanitizers =================== 3 failed, 1 skipped in 357.64s (0:05:57) =================== Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration/./runner", line 492, in subprocess.check_call(cmd, shell=True, bufsize=0) File "/usr/lib/python3.10/subprocess.py", line 369, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command 'docker run --rm --name clickhouse_integration_tests_jwodtn --privileged --dns-search='.' --memory=30709035008 --security-opt seccomp=unconfined --cap-add=SYS_PTRACE --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=5dc43a6382f0 -e DOCKER_BASE_TAG=5ccda723c1fc -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=d862517635bf -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=1 --color=no --durations=0 --report-log=parallel0_1.jsonl --report-log-exclude-logs-on-passed-tests test_asynchronous_metric_jemalloc_profile_active/test.py::test_asynchronous_metric_jemalloc_profile_active test_backup_restore_on_cluster/test_different_versions.py::test_different_versions 'test_cow_policy/test.py::test_cow_policy[cow_policy_multi_disk]' 'test_cow_policy/test.py::test_cow_policy[cow_policy_multi_volume]' -vvv " altinityinfra/integration-tests-runner:ad96270260ff ' returned non-zero exit status 1.